Problem Note 44087: Performing a SUBSTR function on a DB2 variable defined as a BLOB might result in a system abend 0C4
Using the SUBSTR() function on a DB2 variable defined as a BLOB in SAS® 9.1 TS1M3 or later might result in an error similar to the following:
ERROR: System abend 0C4 occurred in module function sqxextr_get_next at offset
0000B2.
ERROR: Traceback will be attempted...
NOTE: Traceback called
NOTE: Module Function Offset Line
NOTE: -------- -------- ------ ----
NOTE: SASSQX @@669285 000308 0 sqxcrta_get_next
NOTE: SASSQX @@669271 000A70 0 sqxcrta_open
NOTE: SASSQX @@669257 0001CE 0 sqxcrta_init
NOTE: SASSQX SQXEXEC 00012A 0
NOTE: SASSQX SQLLOOP 000DAC 0
NOTE: SASSQL SASSQL 000302 0
NOTE: SASHOST UNKNOWN 002DC0 0
ERROR: Delete current task.
Currently, SAS/ACCESS® Interface to DB2 in the z/OS environment does not support reading in DB2 data types of BLOB. There is no workaround for this problem.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.1 TS1M3 SP4 | 9.4 TS1M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2011-09-22 21:36:07 |
| Date Created: | 2011-08-24 10:01:42 |
